﻿using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using GrapeCity.Spreadsheet;
using GrapeCity.Spreadsheet.Drawing;
using GrapeCity.CarInsuranceClaim;

using Spread.Common.Features.Sample;

namespace GrapeCity.CarInsuranceClaim
{
    public partial class CarInsuranceClaim  : BaseSampleControl
    {
        public CarInsuranceClaim()
        {
            InitializeComponent();
            fpSpread1.Features.EnhancedShapeEngine = true;
            fpSpread1.Features.RichClipboard = true; 
            using (MemoryStream s = new MemoryStream(ExcelTemplate.car_repair_excel))
            {
                fpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DocumentCaching);
            }
            fpSpread1.ActiveSheet.RowCount = 43;
            IWorkbook workbook = fpSpread1.AsWorkbook();
            for (int n = 0; n < workbook.ActiveSheet.Shapes.Count; n++)
            {
                IShape shape = workbook.ActiveSheet.Shapes[n];
                shape.CanMove = Moving.None;
                shape.CanRotate = false;
                shape.CanSize = Sizing.None;
                if (shape.Name == "Picture 2")
                    continue;
                shape.Action += Shape_Action;
            }
               Bindproperties();
        }

          private void Bindproperties()
          {
               IWorkbook workbook = fpSpread1.AsWorkbook();
               IShapes shapes = workbook.Worksheets[0].Shapes;
               // bind shape properties to cells
               shapes["Front"].Bindings.Add("Left", "Sheet2!B2");
               shapes["Front"].Bindings.Add("Top", "Sheet2!C2");
               shapes["Front"].Bindings.Add("Width", "Sheet2!D2");
               shapes["Front"].Bindings.Add("Height", "Sheet2!E2");
               shapes["Front"].Bindings.Add("Line", "Sheet2!F2");
               shapes["Hood"].Bindings.Add("Left", "Sheet2!B3");
               shapes["Hood"].Bindings.Add("Top", "Sheet2!C3");
               shapes["Hood"].Bindings.Add("Width", "Sheet2!D3");
               shapes["Hood"].Bindings.Add("Height", "Sheet2!E3");
               shapes["Hood"].Bindings.Add("Line", "Sheet2!F3");
               shapes["FrontWindshield"].Bindings.Add("Left", "Sheet2!B4");
               shapes["FrontWindshield"].Bindings.Add("Top", "Sheet2!C4");
               shapes["FrontWindshield"].Bindings.Add("Width", "Sheet2!D4");
               shapes["FrontWindshield"].Bindings.Add("Height", "Sheet2!E4");
               shapes["FrontWindshield"].Bindings.Add("Line", "Sheet2!F4");
               shapes["Roof"].Bindings.Add("Left", "Sheet2!B5");
               shapes["Roof"].Bindings.Add("Top", "Sheet2!C5");
               shapes["Roof"].Bindings.Add("Width", "Sheet2!D5");
               shapes["Roof"].Bindings.Add("Height", "Sheet2!E5");
               shapes["Roof"].Bindings.Add("Line", "Sheet2!F5");
               shapes["RearTop"].Bindings.Add("Left", "Sheet2!B6");
               shapes["RearTop"].Bindings.Add("Top", "Sheet2!C6");
               shapes["RearTop"].Bindings.Add("Width", "Sheet2!D6");
               shapes["RearTop"].Bindings.Add("Height", "Sheet2!E6");
               shapes["RearTop"].Bindings.Add("Line", "Sheet2!F6");
               shapes["Rear"].Bindings.Add("Left", "Sheet2!B7");
               shapes["Rear"].Bindings.Add("Top", "Sheet2!C7");
               shapes["Rear"].Bindings.Add("Width", "Sheet2!D7");
               shapes["Rear"].Bindings.Add("Height", "Sheet2!E7");
               shapes["Rear"].Bindings.Add("Line", "Sheet2!F7");
               shapes["LeftFront"].Bindings.Add("Left", "Sheet2!B8");
               shapes["LeftFront"].Bindings.Add("Top", "Sheet2!C8");
               shapes["LeftFront"].Bindings.Add("Width", "Sheet2!D8");
               shapes["LeftFront"].Bindings.Add("Height", "Sheet2!E8");
               shapes["LeftFront"].Bindings.Add("Line", "Sheet2!F8");
               shapes["LeftFrontDoor"].Bindings.Add("Left", "Sheet2!B9");
               shapes["LeftFrontDoor"].Bindings.Add("Top", "Sheet2!C9");
               shapes["LeftFrontDoor"].Bindings.Add("Width", "Sheet2!D9");
               shapes["LeftFrontDoor"].Bindings.Add("Height", "Sheet2!E9");
               shapes["LeftFrontDoor"].Bindings.Add("Line", "Sheet2!F9");
               shapes["LeftBackDoor"].Bindings.Add("Left", "Sheet2!B10");
               shapes["LeftBackDoor"].Bindings.Add("Top", "Sheet2!C10");
               shapes["LeftBackDoor"].Bindings.Add("Width", "Sheet2!D10");
               shapes["LeftBackDoor"].Bindings.Add("Height", "Sheet2!E10");
               shapes["LeftBackDoor"].Bindings.Add("Line", "Sheet2!F10");
               shapes["LeftBack"].Bindings.Add("Left", "Sheet2!B11");
               shapes["LeftBack"].Bindings.Add("Top", "Sheet2!C11");
               shapes["LeftBack"].Bindings.Add("Width", "Sheet2!D11");
               shapes["LeftBack"].Bindings.Add("Height", "Sheet2!E11");
               shapes["LeftBack"].Bindings.Add("Line", "Sheet2!F11");
               shapes["RightFront"].Bindings.Add("Left", "Sheet2!B12");
               shapes["RightFront"].Bindings.Add("Top", "Sheet2!C12");
               shapes["RightFront"].Bindings.Add("Width", "Sheet2!D12");
               shapes["RightFront"].Bindings.Add("Height", "Sheet2!E12");
               shapes["RightFront"].Bindings.Add("Line", "Sheet2!F12");
               shapes["RightFrontDoor"].Bindings.Add("Left", "Sheet2!B13");
               shapes["RightFrontDoor"].Bindings.Add("Top", "Sheet2!C13");
               shapes["RightFrontDoor"].Bindings.Add("Width", "Sheet2!D13");
               shapes["RightFrontDoor"].Bindings.Add("Height", "Sheet2!E13");
               shapes["RightFrontDoor"].Bindings.Add("Line", "Sheet2!F13");
               shapes["RightBackDoor"].Bindings.Add("Left", "Sheet2!B14");
               shapes["RightBackDoor"].Bindings.Add("Top", "Sheet2!C14");
               shapes["RightBackDoor"].Bindings.Add("Width", "Sheet2!D14");
               shapes["RightBackDoor"].Bindings.Add("Height", "Sheet2!E14");
               shapes["RightBackDoor"].Bindings.Add("Line", "Sheet2!F14");
               shapes["RightBack"].Bindings.Add("Left", "Sheet2!B15");
               shapes["RightBack"].Bindings.Add("Top", "Sheet2!C15");
               shapes["RightBack"].Bindings.Add("Width", "Sheet2!D15");
               shapes["RightBack"].Bindings.Add("Height", "Sheet2!E15");
               shapes["RightBack"].Bindings.Add("Line", "Sheet2!F15");
          }   

        private void Shape_Action(object sender, ShapeEventArgs e)
        {
            IWorkbook workbook = fpSpread1.AsWorkbook();
            IWorksheet worksheet = workbook.ActiveSheet;
            IShapes shapes = worksheet.Shapes;
            if (e.Shape != null)
            {
                string name = e.Shape.Name;
                if (e.Shape.Fill.Transparency == 0.99)
                {
                    e.Shape.Fill.Transparency = 0.5;
                    if (name == "Front" || name == "Rear")
                        shapes["BumperDamage"].Fill.Transparency = 0.5;
                    if (name == "Roof")
                        shapes["RoofDamage"].Fill.Transparency = 0.5;
                    if (name == "RoofDamage")
                        shapes["Roof"].Fill.Transparency = 0.5;
                    if (name == "HighSeverity" || name == "MediumSeverity" || name == "LowSeverity")
                    {
                        shapes["HighSeverity"].Fill.Transparency = 0.99;
                        shapes["MediumSeverity"].Fill.Transparency = 0.99;
                        shapes["LowSeverity"].Fill.Transparency = 0.99;
                        shapes[name].Fill.Transparency = 0.5;
                    }
                }
                else
                {
                    e.Shape.Fill.Transparency = 0.99;
                    if (name == "Front" && shapes["Rear"].Fill.Transparency == 0.99)
                        shapes["BumperDamage"].Fill.Transparency = 0.99;
                    if (name == "Rear" && shapes["Front"].Fill.Transparency == 0.99)
                        shapes["BumperDamage"].Fill.Transparency = 0.99;
                    if (name == "Roof")
                        shapes["RoofDamage"].Fill.Transparency = 0.99;
                    if (name == "ReefDamage")
                        shapes["Roof"].Fill.Transparency = 0.99;
                }
            }
        }

        private void SaveToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SaveFileDialog d = new SaveFileDialog();
            d.Filter = "Excel Macro-enabled Workbook (*.XLSM)|*.XLSM";
            d.FilterIndex = 0;
            d.Title = "Save File";
            if (d.ShowDialog() == DialogResult.OK)
            {
                fpSpread1.SaveExcel(d.FileName, FarPoint.Excel.ExcelSaveFlags.DocumentCaching | FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
            }
        }

        private void ExitToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form form = (System.Windows.Forms.Form) this.TopLevelControl;
            form.Close();
        }
    }
}

//
//CarInsuranceClaim.Designer.cs
//

namespace GrapeCity.CarInsuranceClaim
{
     partial class CarInsuranceClaim
     {
          /// <summary> 
          /// Required designer variable.
          /// </summary>
          private System.ComponentModel.IContainer components = null;

          /// <summary> 
          /// Clean up any resources being used.
          /// </summary>
          /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
          //protected override 
          new void Dispose(bool disposing)
          {
               if (disposing && (components != null))
               {
                    components.Dispose();
               }
               base.Dispose(disposing);
          }

          #region Component Designer generated code

          /// <summary> 
          /// Required method for Designer support - do not modify 
          /// the contents of this method with the code editor.
          /// </summary>
          private void InitializeComponent()
          {
               System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
               this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, ((System.IO.MemoryStream)(resources.GetObject("resource1"))));
               this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView();
               this.menuStrip1 = new System.Windows.Forms.MenuStrip();
               this.fileToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
               this.saveToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
               this.toolStripMenuItem1 = new System.Windows.Forms.ToolStripSeparator();
               this.exitToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
               ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
               ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit();
               this.menuStrip1.SuspendLayout();
               this.SuspendLayout();
               // 
               // fpSpread1
               // 
               this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
               this.fpSpread1.Font = new System.Drawing.Font("Calibri", 11F);
               this.fpSpread1.Location = new System.Drawing.Point(0, 24);
               this.fpSpread1.Name = "fpSpread1";
               this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this.fpSpread1_Sheet1});
               this.fpSpread1.Size = new System.Drawing.Size(477, 463);
               this.fpSpread1.TabIndex = 0;
               // 
               // fpSpread1_Sheet1
               // 
               this.fpSpread1_Sheet1.ColumnFooter.DefaultStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.ColumnFooter.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.ColumnFooterSheetCornerStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.ColumnFooterSheetCornerStyle.Font = null;
               this.fpSpread1_Sheet1.ColumnFooterSheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.ColumnFooterSheetCornerStyle.Locked = false;
               this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.FilterBarHeaderStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.FilterBarHeaderStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.RowHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.SheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
               this.fpSpread1_Sheet1.SheetCornerStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
               // 
               // menuStrip1
               // 
               this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.fileToolStripMenuItem});
               this.menuStrip1.Location = new System.Drawing.Point(0, 0);
               this.menuStrip1.Name = "menuStrip1";
               this.menuStrip1.Size = new System.Drawing.Size(889, 24);
               this.menuStrip1.TabIndex = 0;
               this.menuStrip1.Text = "menuStrip1";
               // 
               // fileToolStripMenuItem
               // 
               this.fileToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.saveToolStripMenuItem,
            this.toolStripMenuItem1,
            this.exitToolStripMenuItem});
               this.fileToolStripMenuItem.Name = "fileToolStripMenuItem";
               this.fileToolStripMenuItem.Size = new System.Drawing.Size(37, 20);
               this.fileToolStripMenuItem.Text = "&File";
               // 
               // saveToolStripMenuItem
               // 
               this.saveToolStripMenuItem.Name = "saveToolStripMenuItem";
               this.saveToolStripMenuItem.Size = new System.Drawing.Size(107, 22);
               this.saveToolStripMenuItem.Text = "&Save...";
               this.saveToolStripMenuItem.Click += new System.EventHandler(this.SaveToolStripMenuItem_Click);
               // 
               // toolStripMenuItem1
               // 
               this.toolStripMenuItem1.Name = "toolStripMenuItem1";
               this.toolStripMenuItem1.Size = new System.Drawing.Size(104, 6);
               // 
               // exitToolStripMenuItem
               // 
               this.exitToolStripMenuItem.Name = "exitToolStripMenuItem";
               this.exitToolStripMenuItem.Size = new System.Drawing.Size(107, 22);
               this.exitToolStripMenuItem.Text = "E&xit";
               this.exitToolStripMenuItem.Click += new System.EventHandler(this.ExitToolStripMenuItem_Click);
               // 
               // Form1
               // 
               this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
               this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
               this.ClientSize = new System.Drawing.Size(889, 893);
               this.pnlMain.Controls.Add(this.fpSpread1);
               this.pnlMain.Controls.Add(this.menuStrip1);
               this.Name = "Form1";
               this.Text = "Form1";
               ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
               ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit();
               this.menuStrip1.ResumeLayout(false);
               this.menuStrip1.PerformLayout();
               this.ResumeLayout(false);
               this.PerformLayout();

          }
          #endregion

          private System.Windows.Forms.MenuStrip menuStrip1;
          private System.Windows.Forms.ToolStripMenuItem fileToolStripMenuItem;
          private System.Windows.Forms.ToolStripMenuItem saveToolStripMenuItem;
          private System.Windows.Forms.ToolStripSeparator toolStripMenuItem1;
          private System.Windows.Forms.ToolStripMenuItem exitToolStripMenuItem;
          private FarPoint.Win.Spread.FpSpread fpSpread1;
          private FarPoint.Win.Spread.SheetView fpSpread1_Sheet1;
     }
}
